You are here: Revised Table Definitions > FO_External_Form_Definitions

FO_External_Form_Definitions

Not required maintenance but needed for embedding external reports using Microsoft SQL server reporting URL based pointers. (The external URLs made using SSRS reporting function.)

 

Field

Type

Notes

ExternalForms_ID

bigint

Identity (counter) field

ExternalFormCode

varchar(50)

Unique code string to identify a single report.

Description

varchar(255)

Description for the report.

ReportURL

varchar(800)

URL that launches the report in the SSRS server.

ReportType

varchar(50)

A short coded value that identifies the type of the report.

Use valid XXXX code (of what nature?)

CreateDate

datetime

Date record was created. Informational

EditDate

datetime

Date record was edited. Informational

CreateUser

varchar(50)

User who created the record. Informational

EditUser

varchar(50)

User who edited the record. Informational

FPModule

varchar(50)

Swaps the default Rhodes format for the SSRS form defined.

Use a valid FPModule code to enable.

Valid FPModule Code:

BATCHPROCESS

PermGroups

varchar(1000)

Determines which users can see a report based on permission group codes.

Leave blank to make report available to all users.

Multidimensional pipe delimited value.

Use valid permission group codes separated by pipes with leading and trailing pipes.